
DROP TABLE IF EXISTS jms_dm.dm_fwzl_over_nomarl_waybill_detail;

create external table jms_dm.dm_fwzl_over_nomarl_waybill_detail
(
bill_code string comment '运单号',
arrival_scan_time date comment '到件扫描时间',
scan_site_code string comment '到件扫描网点code',
scan_site_name string comment '到件扫描网点名称',
scan_site_agent_code string comment '到件扫描代理区code',
scan_site_agent_name string comment '到件扫描代理区名称',
pistol_id string comment '巴枪ID_ef',
weight decimal(10,2) comment '重量_ef',
length decimal(10,2) comment '长_ef',
width decimal(10,2) comment '宽_ef',
height decimal(10,2) comment '高_ef',
len_wid_hei_product decimal(10,2) comment '长x宽x高_ef',
package_inside_charge_weight decimal(10,2) comment '内部计费重量,单位千克',
pick_network_id string comment '寄件网点id',
pick_network_code string comment '寄件网点code',
pick_network_name string comment '寄件网点名称',
pick_agent_code string comment '寄件代理区code',
pick_agent_name string comment '寄件代理区',
pick_virt_code string comment '寄件虚拟代理区code',
pick_virt_name string comment '寄件虚拟代理区',
delivery_time date comment '寄件时间',
customer_code string comment '客户编号code',
customer_name string comment '客户编号名称',
settlement_code string comment '结算方式编码',
settlement_name string comment '结算方式名称',
dispatch_network_id string comment '派件网点id',
dispatch_network_code string comment '派件网点code',
dispatch_network_name string comment '派件网点名称',
dispatch_agent_code string comment '派件代理区code',
dispatch_agent_name string comment '派件代理区名称',
dispatch_virt_code string comment '派件虚拟代理区code',
dispatch_virt_name string comment '派件虚拟代理区',
over_nomarl_type string comment '超标类型',
is_record string comment '是否备案 1-是 0-否'
)
COMMENT '服务质量-超标件明细表'
PARTITIONED BY ( dt STRING COMMENT '')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_fwzl_over_nomarl_waybill_detail'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
    );
